<?php
/**
 * Created by PhpStorm.
 * User: dell1
 * Date: 2016/11/19
 * Time: 23:52
 */
header('Content-Type:text/html;charset=utf-8');
echo '<h2>接收到新用户注册！</h2>';
echo '<p>用户名:'.$_POST['username'].'</p>';
echo '<p>密码:'.$_POST['password'].'</p>';
echo '<p>邮箱:'.$_POST['email'].'</p>';
echo '<p>IP地址:'.$_SERVER['REMOTE_ADDR'].'</p>';
echo '<p>浏览器环境:'.$_SERVER['HTTP_USER_AGENT'].'</p>';
echo '<p>请求来源:'.$_SERVER['HTTP_REFERER'].'</p>';
if(empty($_POST)){
    die('没有表单提交，程序退出');
}
$check_fields=array('username','password','email');
foreach($check_fields as $v){
    if(empty($_POST[$v])){
        die('错误:'.$v.'字段不能为空！');
    }
}
$username=$_POST['username'];
$password=$_POST['password'];
$email=$_POST['email'];
$link=mysqli_connect('localhost','root','','itcast');
if(!$link){
    die('连接数据库失败！'.mysqli_error($link));
}
mysqli_query($link,'set names utf8');
mysqli_query($link,'use `itcast`');
$username=mysqli_real_escape_string($link,$username);
$email=mysqli_real_escape_string($link,$email);
$sql="select`id`from `user` where `username`=`$username`";
$rst=mysqli_query($link,$sql);
if(mysqli_fetch_row($rst)){
    die('用户名已存在，请换个用户名。');
}
$password=md5($password);
$sql="insert into`user` (`username`,`password`,`email`) values ('$username','$password','$email')";
$rst=mysqli_query($link,$sql);
echo "SQL语句:$sql<br>";
if($rst){
    echo '执行成功！';
}else{
    echo '执行失败:'.mysqli_error($link);
}
?>